From 641d501a6aece402bdb6b80251a7965e3ea7afab Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 13 Aug 2026 14:53:42 +0000 Subject: [PATCH] Fix typo in column name in trigger code --- db/schemas/lib/triggers/create/biography_data.m4 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index 1f445eb..e080b8d 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -370,7 +370,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () INTO startdate, commmid FROM comm_membs WHERE comm_membs.animid = NEW.animid - AND comm_membs.comm IS DISTINCT FROM NEW.birthcomm + AND comm_membs.commid IS DISTINCT FROM NEW.birthcomm AND comm_membs.startdate < NEW.entrydate ORDER BY comm_membs.startdate LIMIT 1; -- 2.34.1